﻿CREATE PROCEDURE [dbo].[Leagues_SelectByIDWithChildren]
   @league_id uniqueidentifier
AS
EXEC [dbo].[Leagues_SelectByID] @league_id
EXEC [dbo].[Tournaments_SelectByLeagueId] @league_id
EXEC [dbo].[Tournament_Members_SelectByLeagueId] @league_id
EXEC [dbo].[League_Members_SelectByLeagueId] @league_id
EXEC [dbo].[Tournament_Members_SelectByLeagueId] @league_id


